package com.ny.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import com.ny.domain.EquipmentDO;

/**
 * EquipmentMapper
 *
 * @author MSI-NB
 * @date 2025-03-08 13:14:38
 */
@Mapper
public interface EquipmentMapper {

    /**
     * 通过器材ID查询器材信息
     *
     * @Param equipmentId
     * @Return EquipmentDO
     */
    EquipmentDO selectById(Integer equipmentId);

    /**
     * 通过器材名称查询器材信息
     *
     * @Param equipmentName
     * @Return EquipmentDO
     */
    EquipmentDO selectByName(String equipmentName);

    /**
     * 插入器材信息
     *
     * @Param equipmentDO
     * @Return int
     */
    int insert(EquipmentDO equipmentDO);

    /**
     * 更新器材信息
     *
     * @Param equipmentDO
     * @Return int
     */
    int updateById(EquipmentDO equipmentDO);

    /**
     * 删除器材信息
     *
     * @Param equipmentId
     * @Return int
     */
    int deleteById(Integer equipmentId);

    /**
     * 查询所有器材信息
     *
     * @Return List<EquipmentDO>
     */
    List<EquipmentDO> selectAll();
}
